<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Sorting or pivoting data in grid reports in Flash Mode</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
img_whs3 { border:none; width:17px; height:8px; float:none; border-style:none; }
img_whs4 { border:none; width:16px; height:16px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nAnalyzing data in Flash Mode: Reports and widgets\nSorting and pivoting grid reports in Flash Mode");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Sorting or pivoting data in grid reports in Flash Mode</h1>
<p>The steps below show you how to sort or pivot data in grids in documents 
 that are viewed in Flash Mode. To sort or pivot data in a document that 
 is not viewed in Flash Mode, see 
<a HREF="Sorting_data.htm">Sorting report 
 results</a>. </p>
<p>You cannot sort or pivot data in grids that contain subtotals. </p>
<h2>Prerequisites </h2>
<ul type="disc" class="whs1">
	
<li class=p><p>You must meet the prerequisites for using Flash Mode. 
 See 
<a href="Flash_Mode.htm">Viewing documents in Flash Mode</a>.</p></li>
</ul>
<h2>To sort data on a grid in a document in Flash Mode</h2>
<ol type="1" class="whs2">
	
<li class=p><p>Open a document that contains at least one grid report.</p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Home </B></span>menu, 
 select <span style="font-weight: bold;"><B>Flash Mode</B></span>. If Flash Mode 
 is not displayed in the <span style="font-weight: bold;"><B>Home </B></span>menu, 
 Flash Mode may not be enabled in the MicroStrategy project or for the 
 particular document you are viewing.</p></li>
	
<li class=p><p>Pass your cursor over the row or column of data to sort. 
 A floating toolbar is displayed.</p></li>
	
<li class=p><p>Do one of the following: </p></li>
</ol>
<ol><ul>
<li style="list-style: disc;" type=disc class=p><p>Click the <img src="images/sort_asc.gif" x-maintain-ratio="TRUE" width="17px" height="8px" border="0" class="img_whs3"> 
 icon to sort the data in ascending order. </p></li>
		
<li style="list-style: disc;" type=disc class=p><p>Click the <img src="images/sort_desc.gif" x-maintain-ratio="TRUE" width="17px" height="8px" border="0" class="img_whs3"> 
 icon to sort the data in descending order. </p></li>
	</ul>
</ol>
<h2>To pivot objects on a grid in a document in Flash Mode</h2>
<ol type="1" class="whs2">
	
<li class=p><p>Open a document that contains at least one grid report.</p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Home </B></span>menu, 
 select <span style="font-weight: bold;"><B>Flash Mode</B></span>. If Flash Mode 
 is not displayed in the <span style="font-weight: bold;"><B>Home </B></span>menu, 
 Flash Mode may not be enabled in the MicroStrategy project or for the 
 particular document you are viewing.</p></li>
	
<li class=p><p>Pass your cursor over the object to pivot. A floating 
 toolbar is displayed.</p></li>
	
<li class=p><p>When pivoting objects, keep all attributes together 
 and keep all metrics together. To do this, ensure that all attributes 
 are in either the rows or the columns, and that all metrics are in either 
 the rows or the columns. To pivot objects, use the following buttons: 
 </p></li>
</ol>
<ol><ul>
<li style="list-style: disc;" type=disc class=p><p>Move the object 
 to the left. <img src="images/arrow_shiftleft.gif" x-maintain-ratio="TRUE" width="16px" height="16px" border="0" class="img_whs4"></p></li>
		
<li style="list-style: disc;" type=disc class=p><p>Move the object 
 to the right. <img src="images/arrow_shiftright.gif" x-maintain-ratio="TRUE" width="16px" height="16px" border="0" class="img_whs4"></p></li>
		
<li style="list-style: disc;" type=disc class=p><p>Move the object 
 to the columns. <img src="images/arrow_rightup.gif" x-maintain-ratio="TRUE" width="16px" height="16px" border="0" class="img_whs4"></p></li>
		
<li style="list-style: disc;" type=disc class=p><p>Move the object 
 to the rows. <img src="images/arrow_rightdown.gif" x-maintain-ratio="TRUE" width="16px" height="16px" border="0" class="img_whs4"></p></li>
	</ul>
</ol>
<p>&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
